from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine
import getpath
Base = automap_base()
filedb=getpath.getpath()+r"/./data.db"
engine = create_engine('sqlite:///'+filedb, echo=True)
# reflect the tables
Base.prepare(autoload_with=engine)
# mapped classes are now created with names by default
# matching that of the table name.
print(dir(Base.classes))
